CREATE EXTERNAL TABLE jms_ods.tab_barscan_scan_delete (
billcode string comment'单号'
,packagecode string comment'包号'
,scan_type string comment'扫描类型'
,scan_time timestamp comment'原始单号扫描时间'
,input_time timestamp comment'原始单号落库时间'
,upload_time timestamp comment'上传时间'
,delete_time timestamp comment'删除时间'
,delete_site_id bigint comment'删除网点id'
,delete_site_code string comment'删除网点code'
,delete_site_name string comment'删除网点名称'
,delete_user_code string comment'删除人code'
,delete_user_name string comment'删除人name'
,scan_site_id bigint comment'扫描网点id'
,scan_site_code string comment'扫描网点code'
,scan_site_name string comment'扫描网点名称'
,scan_user_code string comment'扫描人code'
,scan_user_name string comment'扫描人名称'
,device_id string comment'设备号'
,source string comment'来源'
,remark string comment'备注'
,create_time timestamp comment'创建时间'
) comment'操作扫描删除表'
PARTITIONED BY (
  `dt` string COMMENT '分区日期')
STORED AS PARQUET
LOCATION '/dw/hive/jms_ods.db/external/tab_barscan_scan_delete'
TBLPROPERTIES (
    'discover.partitions' = 'false',
    'parquet.column.index.access' = 'true'
);